Chicago Sidewalk Cafe Permits

Dataset statistics

Number of variables	22
Number of observations	22229
Missing cells	4919
Missing cells (%)	1.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	3.7 MiB
Average record size in memory	176.0 B

Variable types

Numeric	10
Text	5
DateTime	2
Categorical	5

Alerts

`CITY` has constant value ""	Constant
`STATE` has constant value ""	Constant
`PERMIT NUMBER` is highly overall correlated with `EXPIRATION DATE`	High correlation
`ADDRESS NUMBER START` is highly overall correlated with `ADDRESS NUMBER` and 3 other fields	High correlation
`ADDRESS NUMBER` is highly overall correlated with `ADDRESS NUMBER START` and 3 other fields	High correlation
`WARD` is highly overall correlated with `POLICE DISTRICT` and 1 other fields	High correlation
`POLICE DISTRICT` is highly overall correlated with `ADDRESS NUMBER START` and 3 other fields	High correlation
`LATITUDE` is highly overall correlated with `ADDRESS NUMBER START` and 4 other fields	High correlation
`LONGITUDE` is highly overall correlated with `ADDRESS NUMBER START` and 2 other fields	High correlation
`EXPIRATION DATE` is highly overall correlated with `PERMIT NUMBER`	High correlation
`STREET TYPE` is highly imbalanced (51.9%)	Imbalance
`STREET TYPE` has 1360 (6.1%) missing values	Missing
`POLICE DISTRICT` has 882 (4.0%) missing values	Missing
`LATITUDE` has 882 (4.0%) missing values	Missing
`LONGITUDE` has 882 (4.0%) missing values	Missing
`LOCATION` has 882 (4.0%) missing values	Missing
`PERMIT NUMBER` has unique values	Unique
`ADDRESS NUMBER START` has 2120 (9.5%) zeros	Zeros
`ADDRESS NUMBER` has 2120 (9.5%) zeros	Zeros

Reproduction

Analysis started	2023-12-06 14:19:49.230622
Analysis finished	2023-12-06 14:20:20.579544
Duration	31.35 seconds
Software version	ydata-profiling vv4.6.1
Download configuration	config.json

PERMIT NUMBER
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	22229
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1173805.5

Minimum	1000571
Maximum	1866738
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	173.8 KiB

Quantile statistics

Minimum	1000571
5-th percentile	1025232.8
Q1	1078376
median	1111341
Q3	1133285
95-th percentile	1696194
Maximum	1866738
Range	866167
Interquartile range (IQR)	54909

Descriptive statistics

Standard deviation	204624.58
Coefficient of variation (CV)	0.17432581
Kurtosis	2.9827699
Mean	1173805.5
Median Absolute Deviation (MAD)	25497
Skewness	2.1097529
Sum	2.6092522 × 10¹⁰
Variance	4.187122 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1556602	1	< 0.1%
1121747	1	< 0.1%
1121759	1	< 0.1%
1121758	1	< 0.1%
1121757	1	< 0.1%
1121756	1	< 0.1%
1121755	1	< 0.1%
1121754	1	< 0.1%
1121749	1	< 0.1%
1121748	1	< 0.1%
Other values (22219)	22219	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1000571	1	< 0.1%
1001307	1	< 0.1%
1002652	1	< 0.1%
1002993	1	< 0.1%
1003612	1	< 0.1%
1004393	1	< 0.1%
1007248	1	< 0.1%
1007265	1	< 0.1%
1007306	1	< 0.1%
1007406	1	< 0.1%

Value	Count	Frequency (%)
1866738	1	< 0.1%
1862206	1	< 0.1%
1860048	1	< 0.1%
1859432	1	< 0.1%
1857612	1	< 0.1%
1855208	1	< 0.1%
1854101	1	< 0.1%
1852797	1	< 0.1%
1852784	1	< 0.1%
1848630	1	< 0.1%

ACCOUNT NUMBER
Real number (ℝ)

Distinct	3301
Distinct (%)	14.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	210983.51

Minimum	12
Maximum	499543
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	173.8 KiB

Quantile statistics

Minimum	12
5-th percentile	5310
Q1	23392
median	261427
Q3	352385
95-th percentile	421498
Maximum	499543
Range	499531
Interquartile range (IQR)	328993

Descriptive statistics

Standard deviation	157608.86
Coefficient of variation (CV)	0.7470198
Kurtosis	-1.581709
Mean	210983.51
Median Absolute Deviation (MAD)	137671
Skewness	-0.11109042
Sum	4.6899524 × 10⁹
Variance	2.4840553 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
63414	956	4.3%
65004	320	1.4%
298727	114	0.5%
50161	87	0.4%
230211	66	0.3%
22633	66	0.3%
369504	65	0.3%
17658	56	0.3%
392906	50	0.2%
267891	48	0.2%
Other values (3291)	20401	91.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
12	6	< 0.1%
13	23	0.1%
16	4	< 0.1%
27	4	< 0.1%
28	11	< 0.1%
46	18	0.1%
51	6	< 0.1%
66	2	< 0.1%
67	20	0.1%
73	17	0.1%

Value	Count	Frequency (%)
499543	1	< 0.1%
496618	1	< 0.1%
496437	1	< 0.1%
495513	1	< 0.1%
495456	1	< 0.1%
494737	1	< 0.1%
494369	1	< 0.1%
494267	1	< 0.1%
493688	1	< 0.1%
493639	1	< 0.1%

SITE NUMBER
Real number (ℝ)

Distinct	105
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.2241666

Minimum	1
Maximum	230
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	173.8 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	2
95-th percentile	21
Maximum	230
Range	229
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	17.947968
Coefficient of variation (CV)	3.4355658
Kurtosis	44.381275
Mean	5.2241666
Median Absolute Deviation (MAD)	0
Skewness	6.1902102
Sum	116128
Variance	322.12957
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	16347	73.5%
2	2564	11.5%
3	661	3.0%
4	318	1.4%
5	229	1.0%
7	124	0.6%
6	106	0.5%
11	98	0.4%
12	96	0.4%
19	94	0.4%
Other values (95)	1592	7.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	16347	73.5%
2	2564	11.5%
3	661	3.0%
4	318	1.4%
5	229	1.0%
6	106	0.5%
7	124	0.6%
8	65	0.3%
9	77	0.3%
10	71	0.3%

Value	Count	Frequency (%)
230	1	< 0.1%
229	1	< 0.1%
228	1	< 0.1%
226	1	< 0.1%
225	1	< 0.1%
224	1	< 0.1%
221	1	< 0.1%
220	1	< 0.1%
218	1	< 0.1%
217	1	< 0.1%

LEGAL NAME
Text

Distinct	3314
Distinct (%)	14.9%
Missing	1
Missing (%)	< 0.1%
Memory size	173.8 KiB

Length

Max length	67
Median length	46
Mean length	21.105498
Min length	4

Characters and Unicode

Total characters	469133
Distinct characters	78
Distinct categories	9 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	726 ?
Unique (%)	3.3%

Sample

1st row	THE LIFEWAY KEFIR SHOP LLC
2nd row	JERRY'S SANDWICHES LS, LLC
3rd row	ETTA RIVER NORTH, LLC
4th row	SQUARE KITCHEN, LLC
5th row	ROCCO'S, LLC

Value	Count	Frequency (%)
inc	9846	12.9%
llc	6789	8.9%
corporation	1690	2.2%
restaurant	1544	2.0%
	1391	1.8%
starbucks	956	1.3%
chicago	935	1.2%
corp	928	1.2%
the	919	1.2%
cafe	755	1.0%
Other values (3905)	50347	66.2%

Most occurring characters

Value	Count	Frequency (%)
	54043	11.5%
C	33256	7.1%
I	31980	6.8%
A	31519	6.7%
N	30772	6.6%
L	29192	6.2%
O	28214	6.0%
R	27812	5.9%
E	27665	5.9%
T	22946	4.9%
Other values (68)	151734	32.3%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	368808	78.6%
Space Separator	54043	11.5%
Other Punctuation	29107	6.2%
Lowercase Letter	8834	1.9%
Decimal Number	7473	1.6%
Dash Punctuation	669	0.1%
Open Punctuation	92	< 0.1%
Close Punctuation	92	< 0.1%
Math Symbol	15	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
C	33256	9.0%
I	31980	8.7%
A	31519	8.5%
N	30772	8.3%
L	29192	7.9%
O	28214	7.7%
R	27812	7.5%
E	27665	7.5%
T	22946	6.2%
S	22268	6.0%
Other values (16)	83184	22.6%

Lowercase Letter

Value	Count	Frequency (%)
e	1006	11.4%
a	1004	11.4%
n	882	10.0%
o	736	8.3%
t	661	7.5%
r	639	7.2%
i	630	7.1%
s	563	6.4%
c	482	5.5%
l	420	4.8%
Other values (16)	1811	20.5%

Other Punctuation

Value	Count	Frequency (%)
.	12836	44.1%
,	12329	42.4%
'	2488	8.5%
&	1222	4.2%
#	98	0.3%
/	81	0.3%
"	38	0.1%
@	7	< 0.1%
!	6	< 0.1%
:	1	< 0.1%

Decimal Number

Value	Count	Frequency (%)
1	1393	18.6%
2	1052	14.1%
0	942	12.6%
5	890	11.9%
3	848	11.3%
4	793	10.6%
8	522	7.0%
6	383	5.1%
7	369	4.9%
9	281	3.8%

Space Separator

Value	Count	Frequency (%)
	54043	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	669	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	92	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	92	100.0%

Math Symbol

Value	Count	Frequency (%)
+	15	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	377642	80.5%
Common	91491	19.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
C	33256	8.8%
I	31980	8.5%
A	31519	8.3%
N	30772	8.1%
L	29192	7.7%
O	28214	7.5%
R	27812	7.4%
E	27665	7.3%
T	22946	6.1%
S	22268	5.9%
Other values (42)	92018	24.4%

Common

Value	Count	Frequency (%)
	54043	59.1%
.	12836	14.0%
,	12329	13.5%
'	2488	2.7%
1	1393	1.5%
&	1222	1.3%
2	1052	1.1%
0	942	1.0%
5	890	1.0%
3	848	0.9%
Other values (16)	3448	3.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	469133	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	54043	11.5%
C	33256	7.1%
I	31980	6.8%
A	31519	6.7%
N	30772	6.6%
L	29192	6.2%
O	28214	6.0%
R	27812	5.9%
E	27665	5.9%
T	22946	4.9%
Other values (68)	151734	32.3%

DOING BUSINESS AS NAME
Text

Distinct	3384
Distinct (%)	15.2%
Missing	1
Missing (%)	< 0.1%
Memory size	173.8 KiB

Length

Max length	88
Median length	48
Mean length	16.86454
Min length	1

Characters and Unicode

Total characters	374865
Distinct characters	77
Distinct categories	9 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	714 ?
Unique (%)	3.2%

Sample

1st row	LIFEWAY KEFIR SHOP
2nd row	JERRY'S SANDWICHES
3rd row	ETTA
4th row	FORK
5th row	RANALLI'S

Value	Count	Frequency (%)
	2641	4.3%
cafe	1547	2.5%
the	1500	2.4%
coffee	1477	2.4%
restaurant	1456	2.4%
bar	1287	2.1%
grill	1143	1.9%
starbucks	973	1.6%
inc	829	1.3%
and	709	1.1%
Other values (3763)	48167	78.0%

Most occurring characters

Value	Count	Frequency (%)
	39650	10.6%
A	31157	8.3%
E	28748	7.7%
R	22103	5.9%
O	21661	5.8%
S	21416	5.7%
I	19403	5.2%
T	19326	5.2%
N	18782	5.0%
C	16293	4.3%
Other values (67)	136326	36.4%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	296508	79.1%
Space Separator	39650	10.6%
Lowercase Letter	21182	5.7%
Other Punctuation	10379	2.8%
Decimal Number	6579	1.8%
Dash Punctuation	513	0.1%
Math Symbol	50	< 0.1%
Open Punctuation	2	< 0.1%
Close Punctuation	2	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	31157	10.5%
E	28748	9.7%
R	22103	7.5%
O	21661	7.3%
S	21416	7.2%
I	19403	6.5%
T	19326	6.5%
N	18782	6.3%
C	16293	5.5%
L	15909	5.4%
Other values (16)	81710	27.6%

Lowercase Letter

Value	Count	Frequency (%)
e	2665	12.6%
a	2577	12.2%
o	1717	8.1%
n	1684	8.0%
i	1560	7.4%
r	1508	7.1%
t	1276	6.0%
s	1237	5.8%
l	1232	5.8%
u	792	3.7%
Other values (15)	4934	23.3%

Other Punctuation

Value	Count	Frequency (%)
'	4575	44.1%
&	2037	19.6%
#	1389	13.4%
.	989	9.5%
,	669	6.4%
/	620	6.0%
"	46	0.4%
!	43	0.4%
@	8	0.1%
;	2	< 0.1%

Decimal Number

Value	Count	Frequency (%)
2	1603	24.4%
1	975	14.8%
4	679	10.3%
3	661	10.0%
5	652	9.9%
0	585	8.9%
7	433	6.6%
6	380	5.8%
8	307	4.7%
9	304	4.6%

Space Separator

Value	Count	Frequency (%)
	39650	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	513	100.0%

Math Symbol

Value	Count	Frequency (%)
+	50	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	2	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	2	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	317690	84.7%
Common	57175	15.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	31157	9.8%
E	28748	9.0%
R	22103	7.0%
O	21661	6.8%
S	21416	6.7%
I	19403	6.1%
T	19326	6.1%
N	18782	5.9%
C	16293	5.1%
L	15909	5.0%
Other values (41)	102892	32.4%

Common

Value	Count	Frequency (%)
	39650	69.3%
'	4575	8.0%
&	2037	3.6%
2	1603	2.8%
#	1389	2.4%
.	989	1.7%
1	975	1.7%
4	679	1.2%
,	669	1.2%
3	661	1.2%
Other values (16)	3948	6.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	374865	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	39650	10.6%
A	31157	8.3%
E	28748	7.7%
R	22103	5.9%
O	21661	5.8%
S	21416	5.7%
I	19403	5.2%
T	19326	5.2%
N	18782	5.0%
C	16293	4.3%
Other values (67)	136326	36.4%

ISSUED DATE
Date

Distinct	3092
Distinct (%)	13.9%
Missing	0
Missing (%)	0.0%
Memory size	173.8 KiB

Minimum	2001-03-14 00:00:00
Maximum	2023-12-05 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

EXPIRATION DATE
Categorical

HIGH CORRELATION

Distinct	29
Distinct (%)	0.1%
Missing	4
Missing (%)	< 0.1%
Memory size	173.8 KiB

12/01/2017	1227
12/01/2016	1221
02/29/2020	1198
12/01/2015	1196
12/01/2014	1193
Other values (24)	16190

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	222250
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	4 ?
Unique (%)	< 0.1%

Sample

1st row	02/28/2022
2nd row	02/28/2022
3rd row	02/28/2022
4th row	02/28/2022
5th row	02/28/2022

Common Values

Value	Count	Frequency (%)
12/01/2017	1227	5.5%
12/01/2016	1221	5.5%
02/29/2020	1198	5.4%
12/01/2015	1196	5.4%
12/01/2014	1193	5.4%
12/01/2013	1158	5.2%
02/28/2023	1098	4.9%
12/01/2012	1098	4.9%
05/31/2021	1094	4.9%
12/01/2018	1091	4.9%
Other values (19)	10651	47.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
12/01/2017	1227	5.5%
12/01/2016	1221	5.5%
02/29/2020	1198	5.4%
12/01/2015	1196	5.4%
12/01/2014	1193	5.4%
12/01/2013	1158	5.2%
02/28/2023	1098	4.9%
12/01/2012	1098	4.9%
05/31/2021	1094	4.9%
12/01/2018	1091	4.9%
Other values (19)	10651	47.9%

Most occurring characters

Value	Count	Frequency (%)
2	53443	24.0%
0	53106	23.9%
1	49799	22.4%
/	44450	20.0%
8	4466	2.0%
3	3989	1.8%
5	3015	1.4%
9	3002	1.4%
4	2950	1.3%
7	2051	0.9%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	177800	80.0%
Other Punctuation	44450	20.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	53443	30.1%
0	53106	29.9%
1	49799	28.0%
8	4466	2.5%
3	3989	2.2%
5	3015	1.7%
9	3002	1.7%
4	2950	1.7%
7	2051	1.2%
6	1979	1.1%

Other Punctuation

Value	Count	Frequency (%)
/	44450	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	222250	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
2	53443	24.0%
0	53106	23.9%
1	49799	22.4%
/	44450	20.0%
8	4466	2.0%
3	3989	1.8%
5	3015	1.4%
9	3002	1.4%
4	2950	1.3%
7	2051	0.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	222250	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	53443	24.0%
0	53106	23.9%
1	49799	22.4%
/	44450	20.0%
8	4466	2.0%
3	3989	1.8%
5	3015	1.4%
9	3002	1.4%
4	2950	1.3%
7	2051	0.9%

PAYMENT DATE
Date

Distinct	3037
Distinct (%)	13.7%
Missing	22
Missing (%)	0.1%
Memory size	173.8 KiB

Minimum	2001-03-14 00:00:00
Maximum	2023-11-16 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

ADDRESS
Text

Distinct	2822
Distinct (%)	12.7%
Missing	0
Missing (%)	0.0%
Memory size	173.8 KiB

Length

Max length	34
Median length	24
Mean length	16.555491
Min length	10

Characters and Unicode

Total characters	368012
Distinct characters	36
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	481 ?
Unique (%)	2.2%

Sample

1st row	0 W DIVISION ST
2nd row	4739 N LINCOLN AVE
3rd row	0 N CLARK ST
4th row	4600 N LINCOLN AVE
5th row	0 N LINCOLN AVE

Value	Count	Frequency (%)
n	10709	12.1%
st	10586	12.0%
ave	8590	9.7%
w	7758	8.8%
0	2120	2.4%
e	1886	2.1%
s	1876	2.1%
broadway	1201	1.4%
clark	1189	1.3%
lincoln	1166	1.3%
Other values (2005)	41403	46.8%

Most occurring characters

Value	Count	Frequency (%)
	66255	18.0%
A	24443	6.6%
N	22763	6.2%
E	22615	6.1%
S	21618	5.9%
T	17428	4.7%
W	13316	3.6%
1	13020	3.5%
L	12993	3.5%
R	12806	3.5%
Other values (26)	140755	38.2%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	227869	61.9%
Decimal Number	73888	20.1%
Space Separator	66255	18.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	24443	10.7%
N	22763	10.0%
E	22615	9.9%
S	21618	9.5%
T	17428	7.6%
W	13316	5.8%
L	12993	5.7%
R	12806	5.6%
O	12376	5.4%
I	11990	5.3%
Other values (15)	55521	24.4%

Decimal Number

Value	Count	Frequency (%)
1	13020	17.6%
0	11569	15.7%
2	9334	12.6%
3	9263	12.5%
5	8189	11.1%
4	7187	9.7%
6	4626	6.3%
7	4201	5.7%
8	3433	4.6%
9	3066	4.1%

Space Separator

Value	Count	Frequency (%)
	66255	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	227869	61.9%
Common	140143	38.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	24443	10.7%
N	22763	10.0%
E	22615	9.9%
S	21618	9.5%
T	17428	7.6%
W	13316	5.8%
L	12993	5.7%
R	12806	5.6%
O	12376	5.4%
I	11990	5.3%
Other values (15)	55521	24.4%

Common

Value	Count	Frequency (%)
	66255	47.3%
1	13020	9.3%
0	11569	8.3%
2	9334	6.7%
3	9263	6.6%
5	8189	5.8%
4	7187	5.1%
6	4626	3.3%
7	4201	3.0%
8	3433	2.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	368012	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	66255	18.0%
A	24443	6.6%
N	22763	6.2%
E	22615	6.1%
S	21618	5.9%
T	17428	4.7%
W	13316	3.6%
1	13020	3.5%
L	12993	3.5%
R	12806	3.5%
Other values (26)	140755	38.2%

ADDRESS NUMBER START
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	1759
Distinct (%)	7.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1701.2908

Minimum	0
Maximum	11208
Zeros	2120
Zeros (%)	9.5%
Negative	0
Negative (%)	0.0%
Memory size	173.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	217
median	1252
Q3	2732
95-th percentile	5024.6
Maximum	11208
Range	11208
Interquartile range (IQR)	2515

Descriptive statistics

Standard deviation	1673.0133
Coefficient of variation (CV)	0.98337877
Kurtosis	0.91675007
Mean	1701.2908
Median Absolute Deviation (MAD)	1103
Skewness	1.1057587
Sum	37817994
Variance	2798973.5
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2120	9.5%
200	152	0.7%
1	106	0.5%
111	104	0.5%
2100	95	0.4%
20	91	0.4%
400	90	0.4%
175	86	0.4%
731	81	0.4%
100	75	0.3%
Other values (1749)	19229	86.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2120	9.5%
1	106	0.5%
2	21	0.1%
5	17	0.1%
6	63	0.3%
7	7	< 0.1%
8	23	0.1%
9	17	0.1%
10	44	0.2%
11	9	< 0.1%

Value	Count	Frequency (%)
11208	1	< 0.1%
11057	1	< 0.1%
10701	10	< 0.1%
10533	2	< 0.1%
10448	1	< 0.1%
9710	1	< 0.1%
8753	1	< 0.1%
8548	9	< 0.1%
8301	1	< 0.1%
8300	1	< 0.1%

ADDRESS NUMBER
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	1759
Distinct (%)	7.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1701.2908

Minimum	0
Maximum	11208
Zeros	2120
Zeros (%)	9.5%
Negative	0
Negative (%)	0.0%
Memory size	173.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	217
median	1252
Q3	2732
95-th percentile	5024.6
Maximum	11208
Range	11208
Interquartile range (IQR)	2515

Descriptive statistics

Standard deviation	1673.0133
Coefficient of variation (CV)	0.98337877
Kurtosis	0.91675007
Mean	1701.2908
Median Absolute Deviation (MAD)	1103
Skewness	1.1057587
Sum	37817994
Variance	2798973.5
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2120	9.5%
200	152	0.7%
1	106	0.5%
111	104	0.5%
2100	95	0.4%
20	91	0.4%
400	90	0.4%
175	86	0.4%
731	81	0.4%
100	75	0.3%
Other values (1749)	19229	86.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2120	9.5%
1	106	0.5%
2	21	0.1%
5	17	0.1%
6	63	0.3%
7	7	< 0.1%
8	23	0.1%
9	17	0.1%
10	44	0.2%
11	9	< 0.1%

Value	Count	Frequency (%)
11208	1	< 0.1%
11057	1	< 0.1%
10701	10	< 0.1%
10533	2	< 0.1%
10448	1	< 0.1%
9710	1	< 0.1%
8753	1	< 0.1%
8548	9	< 0.1%
8301	1	< 0.1%
8300	1	< 0.1%

STREET DIRECTION
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	173.8 KiB

N	10709
W	7758
E	1886
S	1876

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	22229
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	W
2nd row	N
3rd row	N
4th row	N
5th row	N

Common Values

Value	Count	Frequency (%)
N	10709	48.2%
W	7758	34.9%
E	1886	8.5%
S	1876	8.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
n	10709	48.2%
w	7758	34.9%
e	1886	8.5%
s	1876	8.4%

Most occurring characters

Value	Count	Frequency (%)
N	10709	48.2%
W	7758	34.9%
E	1886	8.5%
S	1876	8.4%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	22229	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
N	10709	48.2%
W	7758	34.9%
E	1886	8.5%
S	1876	8.4%

Most occurring scripts

Value	Count	Frequency (%)
Latin	22229	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
N	10709	48.2%
W	7758	34.9%
E	1886	8.5%
S	1876	8.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	22229	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
N	10709	48.2%
W	7758	34.9%
E	1886	8.5%
S	1876	8.4%

STREET
Text

Distinct	233
Distinct (%)	1.0%
Missing	0
Missing (%)	0.0%
Memory size	173.8 KiB

Length

Max length	24
Median length	17
Mean length	7.0250124
Min length	3

Characters and Unicode

Total characters	156159
Distinct characters	35
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	21 ?
Unique (%)	0.1%

Sample

1st row	DIVISION
2nd row	LINCOLN
3rd row	CLARK
4th row	LINCOLN
5th row	LINCOLN

Value	Count	Frequency (%)
broadway	1201	5.2%
clark	1189	5.1%
lincoln	1166	5.0%
wells	1140	4.9%
division	941	4.1%
michigan	729	3.1%
milwaukee	693	3.0%
southport	667	2.9%
randolph	658	2.8%
state	538	2.3%
Other values (235)	14235	61.5%

Most occurring characters

Value	Count	Frequency (%)
A	15853	10.2%
L	12452	8.0%
O	12376	7.9%
E	12139	7.8%
N	12054	7.7%
I	11990	7.7%
R	11948	7.7%
S	9196	5.9%
D	7357	4.7%
T	6801	4.4%
Other values (25)	43993	28.2%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	154290	98.8%
Decimal Number	941	0.6%
Space Separator	928	0.6%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	15853	10.3%
L	12452	8.1%
O	12376	8.0%
E	12139	7.9%
N	12054	7.8%
I	11990	7.8%
R	11948	7.7%
S	9196	6.0%
D	7357	4.8%
T	6801	4.4%
Other values (15)	42124	27.3%

Decimal Number

Value	Count	Frequency (%)
3	314	33.4%
5	228	24.2%
1	147	15.6%
8	60	6.4%
6	56	6.0%
7	49	5.2%
2	48	5.1%
9	26	2.8%
4	13	1.4%

Space Separator

Value	Count	Frequency (%)
	928	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	154290	98.8%
Common	1869	1.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	15853	10.3%
L	12452	8.1%
O	12376	8.0%
E	12139	7.9%
N	12054	7.8%
I	11990	7.8%
R	11948	7.7%
S	9196	6.0%
D	7357	4.8%
T	6801	4.4%
Other values (15)	42124	27.3%

Common

Value	Count	Frequency (%)
	928	49.7%
3	314	16.8%
5	228	12.2%
1	147	7.9%
8	60	3.2%
6	56	3.0%
7	49	2.6%
2	48	2.6%
9	26	1.4%
4	13	0.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	156159	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	15853	10.2%
L	12452	8.0%
O	12376	7.9%
E	12139	7.8%
N	12054	7.7%
I	11990	7.7%
R	11948	7.7%
S	9196	5.9%
D	7357	4.7%
T	6801	4.4%
Other values (25)	43993	28.2%

STREET TYPE
Categorical

IMBALANCE MISSING

Distinct	9
Distinct (%)	< 0.1%
Missing	1360
Missing (%)	6.1%
Memory size	173.8 KiB

ST	10546
AVE	8590
RD	658
BLVD	280
PL	261
Other values (4)	534

Length

Max length	4
Median length	2
Mean length	2.4605875
Min length	2

Characters and Unicode

Total characters	51350
Distinct characters	15
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	ST
2nd row	AVE
3rd row	ST
4th row	AVE
5th row	AVE

Common Values

Value	Count	Frequency (%)
ST	10546	47.4%
AVE	8590	38.6%
RD	658	3.0%
BLVD	280	1.3%
PL	261	1.2%
PKWY	209	0.9%
DR	200	0.9%
CT	81	0.4%
HWY	44	0.2%
(Missing)	1360	6.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
st	10546	50.5%
ave	8590	41.2%
rd	658	3.2%
blvd	280	1.3%
pl	261	1.3%
pkwy	209	1.0%
dr	200	1.0%
ct	81	0.4%
hwy	44	0.2%

Most occurring characters

Value	Count	Frequency (%)
T	10627	20.7%
S	10546	20.5%
V	8870	17.3%
A	8590	16.7%
E	8590	16.7%
D	1138	2.2%
R	858	1.7%
L	541	1.1%
P	470	0.9%
B	280	0.5%
Other values (5)	840	1.6%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	51350	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
T	10627	20.7%
S	10546	20.5%
V	8870	17.3%
A	8590	16.7%
E	8590	16.7%
D	1138	2.2%
R	858	1.7%
L	541	1.1%
P	470	0.9%
B	280	0.5%
Other values (5)	840	1.6%

Most occurring scripts

Value	Count	Frequency (%)
Latin	51350	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
T	10627	20.7%
S	10546	20.5%
V	8870	17.3%
A	8590	16.7%
E	8590	16.7%
D	1138	2.2%
R	858	1.7%
L	541	1.1%
P	470	0.9%
B	280	0.5%
Other values (5)	840	1.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	51350	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
T	10627	20.7%
S	10546	20.5%
V	8870	17.3%
A	8590	16.7%
E	8590	16.7%
D	1138	2.2%
R	858	1.7%
L	541	1.1%
P	470	0.9%
B	280	0.5%
Other values (5)	840	1.6%

CITY
Categorical

CONSTANT

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	173.8 KiB

CHICAGO	22229

Length

Max length	7
Median length	7
Mean length	7
Min length	7

Characters and Unicode

Total characters	155603
Distinct characters	6
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	CHICAGO
2nd row	CHICAGO
3rd row	CHICAGO
4th row	CHICAGO
5th row	CHICAGO

Common Values

Value	Count	Frequency (%)
CHICAGO	22229	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
chicago	22229	100.0%

Most occurring characters

Value	Count	Frequency (%)
C	44458	28.6%
H	22229	14.3%
I	22229	14.3%
A	22229	14.3%
G	22229	14.3%
O	22229	14.3%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	155603	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
C	44458	28.6%
H	22229	14.3%
I	22229	14.3%
A	22229	14.3%
G	22229	14.3%
O	22229	14.3%

Most occurring scripts

Value	Count	Frequency (%)
Latin	155603	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
C	44458	28.6%
H	22229	14.3%
I	22229	14.3%
A	22229	14.3%
G	22229	14.3%
O	22229	14.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	155603	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
C	44458	28.6%
H	22229	14.3%
I	22229	14.3%
A	22229	14.3%
G	22229	14.3%
O	22229	14.3%

STATE
Categorical

CONSTANT

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	173.8 KiB

IL	22229

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	44458
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	IL
2nd row	IL
3rd row	IL
4th row	IL
5th row	IL

Common Values

Value	Count	Frequency (%)
IL	22229	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
il	22229	100.0%

Most occurring characters

Value	Count	Frequency (%)
I	22229	50.0%
L	22229	50.0%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	44458	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
I	22229	50.0%
L	22229	50.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	44458	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
I	22229	50.0%
L	22229	50.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	44458	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
I	22229	50.0%
L	22229	50.0%

ZIP CODE
Real number (ℝ)

Distinct	53
Distinct (%)	0.2%
Missing	3
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	60626.852

Minimum	60601
Maximum	60707
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	173.8 KiB

Quantile statistics

Minimum	60601
5-th percentile	60603
Q1	60611
median	60618
Q3	60647
95-th percentile	60657
Maximum	60707
Range	106
Interquartile range (IQR)	36

Descriptive statistics

Standard deviation	20.303309
Coefficient of variation (CV)	0.00033488971
Kurtosis	-0.95237657
Mean	60626.852
Median Absolute Deviation (MAD)	11
Skewness	0.57212698
Sum	1.3474924 × 10⁹
Variance	412.22434
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
60657	2235	10.1%
60611	1869	8.4%
60654	1774	8.0%
60622	1759	7.9%
60614	1664	7.5%
60607	1328	6.0%
60613	1170	5.3%
60647	967	4.4%
60610	952	4.3%
60618	908	4.1%
Other values (43)	7600	34.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
60601	656	3.0%
60602	410	1.8%
60603	331	1.5%
60604	234	1.1%
60605	729	3.3%
60606	385	1.7%
60607	1328	6.0%
60608	213	1.0%
60609	32	0.1%
60610	952	4.3%

Value	Count	Frequency (%)
60707	47	0.2%
60661	506	2.3%
60660	350	1.6%
60659	203	0.9%
60657	2235	10.1%
60656	17	0.1%
60655	3	< 0.1%
60654	1774	8.0%
60653	23	0.1%
60651	3	< 0.1%

WARD
Real number (ℝ)

HIGH CORRELATION

Distinct	44
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	32.353862

Minimum	1
Maximum	50
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	173.8 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	27
median	42
Q3	44
95-th percentile	47
Maximum	50
Range	49
Interquartile range (IQR)	17

Descriptive statistics

Standard deviation	16.140922
Coefficient of variation (CV)	0.49888702
Kurtosis	-0.46189472
Mean	32.353862
Median Absolute Deviation (MAD)	5
Skewness	-1.0438656
Sum	719194
Variance	260.52936
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=44)

Value	Count	Frequency (%)
42	5595	25.2%
44	2204	9.9%
27	1699	7.6%
1	1632	7.3%
47	1601	7.2%
2	1392	6.3%
43	1278	5.7%
32	1193	5.4%
4	672	3.0%
46	624	2.8%
Other values (34)	4339	19.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1632	7.3%
2	1392	6.3%
3	293	1.3%
4	672	3.0%
5	104	0.5%
6	1	< 0.1%
8	2	< 0.1%
9	1	< 0.1%
10	13	0.1%
11	339	1.5%

Value	Count	Frequency (%)
50	109	0.5%
49	164	0.7%
48	606	2.7%
47	1601	7.2%
46	624	2.8%
45	270	1.2%
44	2204	9.9%
43	1278	5.7%
42	5595	25.2%
41	91	0.4%

POLICE DISTRICT
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	23
Distinct (%)	0.1%
Missing	882
Missing (%)	4.0%
Infinite	0
Infinite (%)	0.0%
Mean	14.11566

Minimum	0
Maximum	25
Zeros	4
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	173.8 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	12
median	18
Q3	19
95-th percentile	20
Maximum	25
Range	25
Interquartile range (IQR)	7

Descriptive statistics

Standard deviation	6.7903564
Coefficient of variation (CV)	0.48105128
Kurtosis	-0.23988417
Mean	14.11566
Median Absolute Deviation (MAD)	1
Skewness	-1.0661001
Sum	301327
Variance	46.10894
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=23)

Value	Count	Frequency (%)
18	5345	24.0%
19	5064	22.8%
1	3661	16.5%
12	2508	11.3%
14	1789	8.0%
20	988	4.4%
16	419	1.9%
17	374	1.7%
24	364	1.6%
2	239	1.1%
Other values (13)	596	2.7%
(Missing)	882	4.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	4	< 0.1%
1	3661	16.5%
2	239	1.1%
3	10	< 0.1%
4	15	0.1%
5	1	< 0.1%
6	2	< 0.1%
7	1	< 0.1%
8	44	0.2%
9	224	1.0%

Value	Count	Frequency (%)
25	149	0.7%
24	364	1.6%
22	27	0.1%
20	988	4.4%
19	5064	22.8%
18	5345	24.0%
17	374	1.7%
16	419	1.9%
15	7	< 0.1%
14	1789	8.0%

LATITUDE
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	2728
Distinct (%)	12.8%
Missing	882
Missing (%)	4.0%
Infinite	0
Infinite (%)	0.0%
Mean	41.912355

Minimum	41.69067
Maximum	42.019421
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	173.8 KiB

Quantile statistics

Minimum	41.69067
5-th percentile	41.86652
Q1	41.885856
median	41.903246
Q3	41.942224
95-th percentile	41.978607
Maximum	42.019421
Range	0.32875146
Interquartile range (IQR)	0.056368381

Descriptive statistics

Standard deviation	0.038256308
Coefficient of variation (CV)	0.00091276923
Kurtosis	1.5806341
Mean	41.912355
Median Absolute Deviation (MAD)	0.021535653
Skewness	-0.14538575
Sum	894703.04
Variance	0.0014635451
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
41.88200199	98	0.4%
41.88197573	96	0.4%
41.90405052	86	0.4%
41.87801449	81	0.4%
41.88460018	69	0.3%
41.8825402	53	0.2%
41.90186736	40	0.2%
41.89678605	40	0.2%
41.87949547	37	0.2%
41.88216417	37	0.2%
Other values (2718)	20710	93.2%
(Missing)	882	4.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
41.69066951	1	< 0.1%
41.69139989	2	< 0.1%
41.69245222	1	< 0.1%
41.69920305	10	< 0.1%
41.70289718	1	< 0.1%
41.70356373	2	< 0.1%
41.71874411	1	< 0.1%
41.72107515	10	< 0.1%
41.72112515	1	< 0.1%
41.72177014	1	< 0.1%

Value	Count	Frequency (%)
42.01942097	12	0.1%
42.0193885	5	< 0.1%
42.01934594	4	< 0.1%
42.01933013	3	< 0.1%
42.01932963	2	< 0.1%
42.0193098	4	< 0.1%
42.01927235	1	< 0.1%
42.0174068	8	< 0.1%
42.01615704	15	0.1%
42.01615267	15	0.1%

LONGITUDE
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	2728
Distinct (%)	12.8%
Missing	882
Missing (%)	4.0%
Infinite	0
Infinite (%)	0.0%
Mean	-87.654977

Minimum	-87.834308
Maximum	-87.535139
Zeros	0
Zeros (%)	0.0%
Negative	21347
Negative (%)	96.0%
Memory size	173.8 KiB

Quantile statistics

Minimum	-87.834308
5-th percentile	-87.708499
Q1	-87.670876
median	-87.648725
Q3	-87.630567
95-th percentile	-87.624293
Maximum	-87.535139
Range	0.29916895
Interquartile range (IQR)	0.040309124

Descriptive statistics

Standard deviation	0.032511036
Coefficient of variation (CV)	-0.00037089777
Kurtosis	5.6208684
Mean	-87.654977
Median Absolute Deviation (MAD)	0.0196747
Skewness	-1.8308208
Sum	-1871170.8
Variance	0.0010569674
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-87.63103164	98	0.4%
-87.63397185	96	0.4%
-87.62874675	86	0.4%
-87.63318903	81	0.4%
-87.62798897	69	0.3%
-87.62453095	53	0.2%
-87.62849214	40	0.2%
-87.62828088	40	0.2%
-87.63382966	37	0.2%
-87.62451427	37	0.2%
Other values (2718)	20710	93.2%
(Missing)	882	4.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-87.8343079	1	< 0.1%
-87.82625503	9	< 0.1%
-87.82618448	1	< 0.1%
-87.82167425	5	< 0.1%
-87.82042719	4	< 0.1%
-87.81865423	16	0.1%
-87.81795264	4	< 0.1%
-87.81783297	3	< 0.1%
-87.81729036	11	< 0.1%
-87.8172596	2	< 0.1%

Value	Count	Frequency (%)
-87.53513895	2	< 0.1%
-87.55117213	1	< 0.1%
-87.55124869	1	< 0.1%
-87.55161886	9	< 0.1%
-87.56729719	2	< 0.1%
-87.58184369	4	< 0.1%
-87.58390766	1	< 0.1%
-87.58502961	2	< 0.1%
-87.58781452	8	< 0.1%
-87.58797399	7	< 0.1%

LOCATION
Text

MISSING

Distinct	2728
Distinct (%)	12.8%
Missing	882
Missing (%)	4.0%
Memory size	173.8 KiB

Length

Max length	40
Median length	39
Mean length	39.102216
Min length	35

Characters and Unicode

Total characters	834715
Distinct characters	16
Distinct categories	6 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	466 ?
Unique (%)	2.2%

Sample

1st row	(41.90405051948726, -87.62874675447662)
2nd row	(41.96769881732379, -87.68780818484225)
3rd row	(41.88200198545344, -87.6310316367502)
4th row	(41.964902360748326, -87.68627917084095)
5th row	(41.94330292584782, -87.67135515305324)

Value	Count	Frequency (%)
41.88200198545344	98	0.2%
87.6310316367502	98	0.2%
41.881975727713886	96	0.2%
87.63397184627037	96	0.2%
41.90405051948726	86	0.2%
87.62874675447662	86	0.2%
41.878014487249544	81	0.2%
87.63318903001444	81	0.2%
87.62798896732363	69	0.2%
41.884600177780484	69	0.2%
Other values (5446)	41834	98.0%

Most occurring characters

Value	Count	Frequency (%)
8	89124	10.7%
4	80725	9.7%
7	78215	9.4%
6	76523	9.2%
1	74206	8.9%
9	66936	8.0%
2	56948	6.8%
3	56186	6.7%
5	55910	6.7%
0	50513	6.1%
Other values (6)	149429	17.9%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	685286	82.1%
Other Punctuation	64041	7.7%
Open Punctuation	21347	2.6%
Space Separator	21347	2.6%
Dash Punctuation	21347	2.6%
Close Punctuation	21347	2.6%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
8	89124	13.0%
4	80725	11.8%
7	78215	11.4%
6	76523	11.2%
1	74206	10.8%
9	66936	9.8%
2	56948	8.3%
3	56186	8.2%
5	55910	8.2%
0	50513	7.4%

Other Punctuation

Value	Count	Frequency (%)
.	42694	66.7%
,	21347	33.3%

Open Punctuation

Value	Count	Frequency (%)
(	21347	100.0%

Space Separator

Value	Count	Frequency (%)
	21347	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	21347	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	21347	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	834715	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
8	89124	10.7%
4	80725	9.7%
7	78215	9.4%
6	76523	9.2%
1	74206	8.9%
9	66936	8.0%
2	56948	6.8%
3	56186	6.7%
5	55910	6.7%
0	50513	6.1%
Other values (6)	149429	17.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	834715	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
8	89124	10.7%
4	80725	9.7%
7	78215	9.4%
6	76523	9.2%
1	74206	8.9%
9	66936	8.0%
2	56948	6.8%
3	56186	6.7%
5	55910	6.7%
0	50513	6.1%
Other values (6)	149429	17.9%

Auto

Heatmap
Table

	PERMIT NUMBER	ACCOUNT NUMBER	SITE NUMBER	ADDRESS NUMBER START	ADDRESS NUMBER	ZIP CODE	WARD	POLICE DISTRICT	LATITUDE	LONGITUDE	EXPIRATION DATE	STREET DIRECTION	STREET TYPE
PERMIT NUMBER	1.000	0.473	0.011	-0.255	-0.255	-0.003	-0.052	-0.149	-0.136	0.037	0.871	0.029	0.001
ACCOUNT NUMBER	0.473	1.000	-0.185	-0.141	-0.141	-0.035	-0.087	-0.143	-0.124	0.017	0.270	0.070	0.068
SITE NUMBER	0.011	-0.185	1.000	-0.107	-0.107	-0.089	0.060	-0.053	-0.072	0.143	0.032	0.069	0.056
ADDRESS NUMBER START	-0.255	-0.141	-0.107	1.000	1.000	0.361	0.227	0.561	0.734	-0.720	0.101	0.298	0.197
ADDRESS NUMBER	-0.255	-0.141	-0.107	1.000	1.000	0.361	0.227	0.561	0.734	-0.720	0.101	0.298	0.197
ZIP CODE	-0.003	-0.035	-0.089	0.361	0.361	1.000	0.247	0.488	0.475	-0.444	0.012	0.314	0.225
WARD	-0.052	-0.087	0.060	0.227	0.227	0.247	1.000	0.563	0.518	-0.070	0.019	0.296	0.167
POLICE DISTRICT	-0.149	-0.143	-0.053	0.561	0.561	0.488	0.563	1.000	0.829	-0.342	0.080	0.392	0.186
LATITUDE	-0.136	-0.124	-0.072	0.734	0.734	0.475	0.518	0.829	1.000	-0.621	0.089	0.392	0.212
LONGITUDE	0.037	0.017	0.143	-0.720	-0.720	-0.444	-0.070	-0.342	-0.621	1.000	0.041	0.317	0.268
EXPIRATION DATE	0.871	0.270	0.032	0.101	0.101	0.012	0.019	0.080	0.089	0.041	1.000	0.017	0.000
STREET DIRECTION	0.029	0.070	0.069	0.298	0.298	0.314	0.296	0.392	0.392	0.317	0.017	1.000	0.242
STREET TYPE	0.001	0.068	0.056	0.197	0.197	0.225	0.167	0.186	0.212	0.268	0.000	0.242	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	PERMIT NUMBER	ACCOUNT NUMBER	SITE NUMBER	LEGAL NAME	DOING BUSINESS AS NAME	ISSUED DATE	EXPIRATION DATE	PAYMENT DATE	ADDRESS	ADDRESS NUMBER START	ADDRESS NUMBER	STREET DIRECTION	STREET	STREET TYPE	CITY	STATE	ZIP CODE	WARD	POLICE DISTRICT	LATITUDE	LONGITUDE	LOCATION
0	1556602	328992	1	THE LIFEWAY KEFIR SHOP LLC	LIFEWAY KEFIR SHOP	07/16/2021	02/28/2022	07/16/2021	0 W DIVISION ST	0	0	W	DIVISION	ST	CHICAGO	IL	60622.0	1	18.0	41.904051	-87.628747	(41.90405051948726, -87.62874675447662)
1	1531303	399498	1	JERRY'S SANDWICHES LS, LLC	JERRY'S SANDWICHES	07/16/2021	02/28/2022	07/16/2021	4739 N LINCOLN AVE	4739	4739	N	LINCOLN	AVE	CHICAGO	IL	60625.0	47	19.0	41.967699	-87.687808	(41.96769881732379, -87.68780818484225)
2	1553078	463188	1	ETTA RIVER NORTH, LLC	ETTA	07/16/2021	02/28/2022	07/16/2021	0 N CLARK ST	0	0	N	CLARK	ST	CHICAGO	IL	60654.0	2	1.0	41.882002	-87.631032	(41.88200198545344, -87.6310316367502)
3	1534556	252742	1	SQUARE KITCHEN, LLC	FORK	07/16/2021	02/28/2022	07/16/2021	4600 N LINCOLN AVE	4600	4600	N	LINCOLN	AVE	CHICAGO	IL	60625.0	47	19.0	41.964902	-87.686279	(41.964902360748326, -87.68627917084095)
4	1556006	337178	1	ROCCO'S, LLC	RANALLI'S	07/16/2021	02/28/2022	07/16/2021	0 N LINCOLN AVE	0	0	N	LINCOLN	AVE	CHICAGO	IL	60614.0	43	NaN	NaN	NaN	None
5	1536621	414414	1	BBSC #4 LLC	BROWN BAG SEAFOOD CO.	07/16/2021	02/28/2022	07/16/2021	3400 N LINCOLN AVE	3400	3400	N	LINCOLN	AVE	CHICAGO	IL	60657.0	47	19.0	41.943303	-87.671355	(41.94330292584782, -87.67135515305324)
6	1559950	34063	1	GASTHAUS ZUM LOEWEN, INC.	THE REVELER	07/16/2021	02/28/2022	07/16/2021	0 W ROSCOE ST	0	0	W	ROSCOE	ST	CHICAGO	IL	60657.0	32	NaN	NaN	NaN	None
7	1540360	23957	1	TEMPO CAFE LIMITED	TEMPO CAFE	07/16/2021	02/28/2022	07/15/2021	6 E CHESTNUT ST	6	6	E	CHESTNUT	ST	CHICAGO	IL	60611.0	2	18.0	41.898431	-87.628009	(41.89843137207629, -87.6280091630558)
8	1543349	425540	1	MI FOGATA INC.	MI FOGATA INC.	07/16/2021	02/28/2022	07/16/2021	4322 N WESTERN AVE	4322	4322	N	WESTERN	AVE	CHICAGO	IL	60618.0	47	19.0	41.960229	-87.688800	(41.96022917610446, -87.68880023680377)
9	1555187	340126	1	SHINE RESTAURANT CORP.	SHINE RESTAURANT, RISE SUSHI RESTAURANT	07/17/2021	02/28/2022	07/14/2021	0 W WEBSTER AVE	0	0	W	WEBSTER	AVE	CHICAGO	IL	60614.0	43	NaN	NaN	NaN	None

	PERMIT NUMBER	ACCOUNT NUMBER	SITE NUMBER	LEGAL NAME	DOING BUSINESS AS NAME	ISSUED DATE	EXPIRATION DATE	PAYMENT DATE	ADDRESS	ADDRESS NUMBER START	ADDRESS NUMBER	STREET DIRECTION	STREET	STREET TYPE	CITY	STATE	ZIP CODE	WARD	POLICE DISTRICT	LATITUDE	LONGITUDE	LOCATION
22219	1838027	415210	1	AREPA GEORGE LP	AREPA GEORGE	07/24/2023	02/29/2024	07/24/2023	0 N KEDZIE AVE	0	0	N	KEDZIE	AVE	CHICAGO	IL	60651.0	26	11.0	41.881016	-87.706271	(41.881015948678254, -87.7062708302215)
22220	1807040	477377	1	SILA'S MEDITERRANEAN, INC.	SILA'S MEDITERRANEAN	07/24/2023	02/29/2024	07/24/2023	0 N BROADWAY	0	0	N	BROADWAY	None	CHICAGO	IL	60657.0	44	NaN	NaN	NaN	None
22221	1845400	370196	5	CHICAGO LOCAL MARKETS LLC	ROOST CHICKEN & BISCUITS	07/24/2023	02/29/2024	07/24/2023	455 N MILWAUKEE AVE	455	455	N	MILWAUKEE	AVE	CHICAGO	IL	60654.0	27	12.0	41.890246	-87.645909	(41.890245551519065, -87.64590936487818)
22222	1780039	5948	9	FRONTERA GRILL, INC.	FRONTERA GRILL/TOPOLOBAMPO/BAR SOTANO	07/24/2023	02/29/2024	07/24/2023	0 N CLARK ST	0	0	N	CLARK	ST	CHICAGO	IL	60654.0	42	1.0	41.882002	-87.631032	(41.88200198545344, -87.6310316367502)
22223	1779609	393307	1	ALULU LLC	ALULU	07/25/2023	02/29/2024	07/25/2023	0 S LAFLIN ST	0	0	S	LAFLIN	ST	CHICAGO	IL	60608.0	25	12.0	41.881448	-87.664564	(41.8814479951026, -87.6645642415278)
22224	1824848	491975	1	DIVISION BAR AND RESTAURANT LLC	Desert Hawk	07/26/2023	02/29/2024	07/26/2023	2049 W DIVISION ST	2049	2049	W	DIVISION	ST	CHICAGO	IL	60622.0	1	12.0	41.903046	-87.679195	(41.903045577773014, -87.67919511353082)
22225	1807568	494267	1	NESH MEDITERRANEAN GRILL LLC	NESH MEDITERRANEAN GRILL	07/26/2023	02/29/2024	07/26/2023	205 W MONROE ST	205	205	W	MONROE	ST	CHICAGO	IL	60606.0	42	1.0	41.880548	-87.633981	(41.880547897806615, -87.63398066695044)
22226	1799606	282836	1	VOLO RESTAURANT LLC	VOLO RESTAURANT	07/26/2023	02/29/2024	07/26/2023	0 W ROSCOE ST	0	0	W	ROSCOE	ST	CHICAGO	IL	60618.0	32	NaN	NaN	NaN	None
22227	1805009	21010	1	KITSCH'N ON ROSCOE, INC.	KITSCH'N ON ROSCOE	07/28/2023	02/29/2024	07/28/2023	2005 W ROSCOE ST	2005	2005	W	ROSCOE	ST	CHICAGO	IL	60618.0	32	19.0	41.943105	-87.678679	(41.94310456354472, -87.67867885196078)
22228	1783094	424543	2	1253 W 18TH STREET, LLC	Sushi Hoshi	07/28/2023	02/29/2024	07/28/2023	0 S LAFLIN ST	0	0	S	LAFLIN	ST	CHICAGO	IL	60608.0	25	12.0	41.881448	-87.664564	(41.8814479951026, -87.6645642415278)

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Lowercase Letter

Other Punctuation

Decimal Number

Space Separator

Dash Punctuation

Open Punctuation

Close Punctuation

Math Symbol

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Lowercase Letter

Other Punctuation

Decimal Number

Space Separator

Dash Punctuation

Math Symbol

Open Punctuation

Close Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Other Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Decimal Number

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters